| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
manipulating formula values
Hi, i'm trying to use the values returned by a formula to create another formula. In other words, I have 2 columns. The first being a =vlookup() formula, the second being a number. I would like to compare the value returned by vlookup and the number in the second column. how do i do this? ramy -- Ramy ------------------------------------------------------------------------ Ramy's Profile: http://www.excelforum.com/member.php...o&userid=16538 View this thread: http://www.excelforum.com/showthread...hreadid=318789 |
|
#2
|
|||
|
|||
|
Hi Ramy
in the third column type =A1=B1 where A1 is the cell containing the result of the VLOOKUP and B1 is the cell containing your number. You'll get a TRUE if they match and a FALSE if they don't. Cheers JulieD "Ramy" wrote in message ... Hi, i'm trying to use the values returned by a formula to create another formula. In other words, I have 2 columns. The first being a =vlookup() formula, the second being a number. I would like to compare the value returned by vlookup and the number in the second column. how do i do this? ramy -- Ramy ------------------------------------------------------------------------ Ramy's Profile: http://www.excelforum.com/member.php...o&userid=16538 View this thread: http://www.excelforum.com/showthread...hreadid=318789 |
|
#3
|
|||
|
|||
|
doesn't seem to be working for me. I'm doing =A1=B1 where A1 and B1 have the same value as far as I can see. I'm getting FALSE. -- Ramy ------------------------------------------------------------------------ Ramy's Profile: http://www.excelforum.com/member.php...o&userid=16538 View this thread: http://www.excelforum.com/showthread...hreadid=318789 |
|
#4
|
|||
|
|||
|
never mind. i just needed to =Trim() the comparative column. Thanks for your help! -- Ramy ------------------------------------------------------------------------ Ramy's Profile: http://www.excelforum.com/member.php...o&userid=16538 View this thread: http://www.excelforum.com/showthread...hreadid=318789 |
|
#5
|
|||
|
|||
|
Hi Ramy
glad it's sorted .. thanks for the feedback Cheers JulieD "Ramy" wrote in message ... never mind. i just needed to =Trim() the comparative column. Thanks for your help! -- Ramy ------------------------------------------------------------------------ Ramy's Profile: http://www.excelforum.com/member.php...o&userid=16538 View this thread: http://www.excelforum.com/showthread...hreadid=318789 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
| Formula values only | New Users to Excel | |||
| Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
