If column A contains text, vlookup column H on the same row

scorpain · #1 11-06-2015, 01:36 AM

Hello everyone.
Apologies I can't attach an example as I'm at work and can't access the Internet on the computer. So I'll try my best to explain.
I'm trying to work out a formula that starts with an if.
If(F5:F39<>"",Vlookup(this is what I'm struggling with, operator,2,False),"")

The struggling with part is that for example
If F7 contains text, the lookup_value is in A7, if F18 contains text then the lookup_value is in F18 but I don't know how to do that.

Thank-you for reading and thinking this through with me.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
documents saved with double column revert to single column when re-opened	danw	Word	6	04-08-2015 06:24 AM
Embedded Excel in Powerpoint - custom animation, display column by column	andytheanimal	PowerPoint	2	01-20-2015 06:30 AM
How can I temporarily break a 3 column format in order to type a single column paragraph	William P	Word	1	01-04-2015 06:40 PM
Want a quotient using a constant to show up in column c each time a number is added to column b	fibbermcghee	Excel	2	12-09-2014 05:48 PM
Parsing 'FullName' column - help needed text to column	ScottA	Excel Programming	3	05-06-2014 12:49 PM