Camparing two values to be eual but if same return another value from another column
I am comparing two spreadsheets in column A is titled: Provider ID on both sheets.
On the second sheet there is a column titled: Clinic Name.
How do I write the formula to say if both values are the same in the Provider ID column then take The clinic name on the second sheet and put into a column H on the first sheet?
you could use a vlookup, something like this in a cell in H of the one sheet... =VLOOKUP(A2,Sheet2!$A:$B,2,FALSE)
where sheet2 is the second sheet with the clinic name in column B.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Put this formula in the 1st Sheet in cell H2. This is assuming your second Sheet is called "Sheet2" If your data starts in another row other than 2 then paste formula into that row and change the 2's in the formula to the corresponding row.
=IF($A2=Sheet2!$A2,Sheet2!$B2,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks