VLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

if the table column that is being used for column index contains formuales
the vlookup results in an error message unless that column is paste special
with values. Is there any way to overcome this ?

Thanks
 
Om my testing VLOOKUP worked OK with your scenario (unless I misunderstand)

Can you give an example of the problem, with the various formulae?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic col_index_num in VLOOKUP? 5
Vlookup return Zero if not there 2
Can't Explain N/A in Vlookup 2
Need VLOOKUP to Work Two Ways 0
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Vlookup and return sheet name also 2
Vlookup and "value" 1
Excel IF statement with vlookup 2

Back
Top