Forum Discussion
Solved
Vlookup errors with parenthetic numbers
I am trying to make Vlookup find values from a table when values are listed by different names. When I download data from web, my lookup value comes into spreadsheet as (14) Miami (FL), or (10) Texas...
It works, I changed the 3 to reference cell D18, so any value i put in D18 will be the column it will look at:
that's column 4
column 5
column 6
column 7
column 8
Here's a refreshed file with 2 other variant formulas:
Take your pick
try testing it again
I'm sorry. I wasn't clear. With your original formula you were able to find the value of C8 and put that value in B18. That's exactly what I was hoping to accomplish. However, I also need the value of D8 to be put in C18, so that B18 and C18 have the value of C8 and D8. I tried adjusting your formula by changing 3 to 4 at the end, hoping the formula would find the value in the fourth column of the table, cell D8.
- Wow! Thank you. Is this a formula that require Shift / Control Enter command?