Vlookup if value is more or less than 100k

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
some sample data with explanation would help
0