Hey!
I wrote a custom lookup function to help me out. Its a little difficult to explain, so please look at the uploaded file here.
https://www.dropbox.com/s/sfb7crrql21n26p/for%20upload%20to%20forum.xlsm
The cells highlighted in yellow are what I am looking up. If you notice, the snapshot...
Oh, the fatal #VALUE error! :)
Most a formatting issue somewhere. See if you can clean up all your values, make sure there are no extra spaces at the end and so on.
Upload a sample sheet if all else fails.
VLOOKUP can pull in text data, no problem.
edit: after doing some reading, I...
Hi Injinia!
You could use a bunch of vlookups. Your formula in B2 would look like this:
'=VLOOKUP(A2, Sheet2!B:G, 2, FALSE)'
And copy downwards for the entire column in B.
For C2, it will read
'=VLOOKUP(A2, Sheet2!B:G, 3, FALSE)'
and so on.
I agree this isn't the most efficient way to...