Return a Value in Vlookup Q
 

The following formula looks up the value in E6:E95 where A7 is found
in Column A (if that makes sense)

=IF($A7="","",VLOOKUP($A7,Report!$A$6:$K$95,COLUMN (A$1)+4,FALSE))

Can I adjust above so that it will return the value in an offset row
+1

For example, if my original example would return whatever is displayed
in E20 (because my value that is in A7 is also in Sheet Report!A20, I
want to returns instead what ever is in cell Sheet Report!E21

Hope above makes sense

Return a Value in Vlookup Q
 

One way is to use index/match, then to adjust the MATCH part of it, eg:
=IF($A7="","",INDEX(Report!$E$6:$E$95,MATCH($A7,Re port!$A$6:$A$95,0)+1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Seanie" wrote:
The following formula looks up the value in E6:E95 where A7 is found
in Column A (if that makes sense)

=IF($A7="","",VLOOKUP($A7,Report!$A$6:$K$95,COLUMN (A$1)+4,FALSE))

Can I adjust above so that it will return the value in an offset row
+1

For example, if my original example would return whatever is displayed
in E20 (because my value that is in A7 is also in Sheet Report!A20, I
want to returns instead what ever is in cell Sheet Report!E21

Hope above makes sense

Return a Value in Vlookup Q
 

Thanks Max, works a treat

Return a Value in Vlookup Q
 

welcome, glad to hear
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Seanie" wrote in message
...
Thanks Max, works a treat