Thread: vlookup error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scott@CW Scott@CW is offline
external usenet poster
 
Posts: 62
Default vlookup error

I am getting the folllowing error (#N/A) with the below formula

=VLOOKUP(F1,A20:D680,4,FALSE)

In cell F1 is this formula
='180 Report'!D6

Please help. I am trying to get the column information in column D according
to the value from F1.