Vlookup from left to right.
 

Hi Guys Me again :D

Question, is there a way to get a =VLookup to lookup a value from Say B and
return the Value from A?

I got a report that generates all the time but the order of the report puts
the lookup value in the middle of the DATA i need. so i want to do a lookup
in a table of A:F on any Column within there and lookup the value from a
different location. Say lookup Value From B and return A like i say. Can this
be done?

Vlookup from left to right.
 

Vlookup only works from left-to-right. Use Index/Match:

=INDEX(A:A,MATCH(C1,B:B,0))

Biff

"Gareth - Network analyst."
wrote in message ...
Hi Guys Me again :D

Question, is there a way to get a =VLookup to lookup a value from Say B
and
return the Value from A?

I got a report that generates all the time but the order of the report
puts
the lookup value in the middle of the DATA i need. so i want to do a
lookup
in a table of A:F on any Column within there and lookup the value from a
different location. Say lookup Value From B and return A like i say. Can
this
be done?

Vlookup from left to right.
 

I didnt even think of doing that hahaha, Thanks alot for the assist Valko :D

"T. Valko" wrote:

Vlookup only works from left-to-right. Use Index/Match:

=INDEX(A:A,MATCH(C1,B:B,0))

Biff

"Gareth - Network analyst."
wrote in message ...
Hi Guys Me again :D

Question, is there a way to get a =VLookup to lookup a value from Say B
and
return the Value from A?

I got a report that generates all the time but the order of the report
puts
the lookup value in the middle of the DATA i need. so i want to do a
lookup
in a table of A:F on any Column within there and lookup the value from a
different location. Say lookup Value From B and return A like i say. Can
this
be done?

Vlookup from left to right.
 

You're welcome!

Biff

"Gareth - Network analyst."
wrote in message ...
I didnt even think of doing that hahaha, Thanks alot for the assist Valko
:D

"T. Valko" wrote:

Vlookup only works from left-to-right. Use Index/Match:

=INDEX(A:A,MATCH(C1,B:B,0))

Biff

"Gareth - Network analyst."

wrote in message
...
Hi Guys Me again :D

Question, is there a way to get a =VLookup to lookup a value from Say B
and
return the Value from A?

I got a report that generates all the time but the order of the report
puts
the lookup value in the middle of the DATA i need. so i want to do a
lookup
in a table of A:F on any Column within there and lookup the value from
a
different location. Say lookup Value From B and return A like i say.
Can
this
be done?