Hi
I am trying to do a Vlookup and if statement.
Where VLookup would be a specific cell in sheet 1: B3
And would look for that entry from B3 in a table in sheet 2: Column A
Then if in the table from sheet 2 A:V, column 20 =0, to return a value of 40
and if <10 to return a value of 25
and if >10 would return a value of 5
Thank you in advance.
sue
=if ( vlookup() =0, 40 , if( vlookup() < 10, 25, if( vlookup() > 10 , 5 , "value is 10 or not found")))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
That worked great
thank you
your welcome, thanks for adding the reputation
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks