Vlookup if value is more or less than 100k

Closed
joanie - Apr 12, 2010 at 04:34 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 12, 2010 at 05:00 PM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 12, 2010 at 05:00 PM
some sample data with explanation would help
0