Hi there
I hope someone can help! I would like to use If function and V lookup together
Thanks
Sandy
My spreadsheet
ColumnA ColumnB ColumnC
Grade Value Outcome
E10 0 I would like to use the formula to look up if column A = 0 then the value is correct?
E10 0
E10 1
E11 9
E10 0
E11 0
E11 0
E11 0
E10 0
How can Column "A" = 0?
1-8-2016 5-51-21 AM.jpg
i would like use vlookup to if column A = E10 Then column B is 0
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
To add a file to a new post
To add a file to an existing post.
I think you need to upload a sample sheet so we can see what you're looking at.
Where do the numbers come from in B?
At the moment, from what you've said, you don't need a vlookup.
In B3 (for row 3): =IF(A3="E10",0, formula in B3 before this)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks