Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search data formulas - HELP!!
Hi,
Can anyone Help ? I have a spreadsheet with a list of phone numbers amongst other data columns, I want to look-up those phone numbers in another spreadsheet and if it finds the same phone number return a value of 'YES'. I have tried the usual look-up functions and am not sure if I need to be using 'Match', or another formula ? |
#2
|
|||
|
|||
We wouldn't know unless you tell us the basic layout of your data whether
lookups will work or if index/match is required. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Richard" wrote in message ... Hi, Can anyone Help ? I have a spreadsheet with a list of phone numbers amongst other data columns, I want to look-up those phone numbers in another spreadsheet and if it finds the same phone number return a value of 'YES'. I have tried the usual look-up functions and am not sure if I need to be using 'Match', or another formula ? |
#3
|
|||
|
|||
=IF(ISNUMBER(MATCH(A1,'[Phones.xls]Sheet1'!$A$1:$A$20,0)),"Yes","")
gets the value in A1 and looks it up. -- HTH RP (remove nothere from the email address if mailing direct) "Richard" wrote in message ... Hi, Can anyone Help ? I have a spreadsheet with a list of phone numbers amongst other data columns, I want to look-up those phone numbers in another spreadsheet and if it finds the same phone number return a value of 'YES'. I have tried the usual look-up functions and am not sure if I need to be using 'Match', or another formula ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting data without removing formulas | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
How do I clear a column of data without clearing the formulas? | Excel Discussion (Misc queries) | |||
search formulas | Excel Discussion (Misc queries) |