Vlookup if value is more or less than 100k

Closed
joanie - 12 Apr 2010 à 16:34
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 12 Apr 2010 à 17:00
Hi I have 4 columns on my Sheet 1,
A=Accounts
B= Actual
C=Budget
D=variance

One the next sheet, I want to do a vlookup that is A is equals to account and its more less than $100k, give me the variace.

I hope my question make sense. Thanks for your help in advance

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
12 Apr 2010 à 17:00
some sample data with explanation would help