jungix
07-18-2006, 02:01 PM
Hi,
According to the VBA help, you have to look for a value in the first column of your range with VLookup.
I need to look a value in column A and find the corresponding value in column B, which I do thanks to:
Application.VLookup(string, Columns("A:B"), 2, 0)
Then I need to do it the otherway, and the only way I found yet is to copy column A in column C and use
Application.VLookup(string, Columns("B:C"), 2, 0)
Is there a way to do it directly looking for a value in column B and taking the value in front in column A using Vlookup?
According to the VBA help, you have to look for a value in the first column of your range with VLookup.
I need to look a value in column A and find the corresponding value in column B, which I do thanks to:
Application.VLookup(string, Columns("A:B"), 2, 0)
Then I need to do it the otherway, and the only way I found yet is to copy column A in column C and use
Application.VLookup(string, Columns("B:C"), 2, 0)
Is there a way to do it directly looking for a value in column B and taking the value in front in column A using Vlookup?