Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Roslyn** luv maths
can anyone tell me in excel how to search a number in two different columns?
i would like to search a no. say 5 in columns B and D... if match found to display the corresponding value from column E
ex:
lookup value = 2 , find match in b and d ..... need to display the corresponding value e2 ,i.e, y
b1: 3 d1= 3 e1= x
b2: 2 d2= 2 e2= y
b3: 6 d3= 6 e3= z
b4: 1 d4= 0 e4= a
b5: 4 d5= 4 e5= b
pls help:(... thanks in advance
2 AnswersSoftware1 decade agohow can i display two matches for a single criteria in excel sheet?
consider the cells
A1: red B1: 4
A2: blue B2: 5
A3:red B3: 56
wat sud i do to display both the values in a single cell or two? is there a formula?pls help....
thanks in advance
1 AnswerProgramming & Design1 decade agohow to find amount denominations in excel sheet?
how many hundreds, tens............?
1 AnswerSoftware1 decade agohow to find amount denominations in excel sheet?
for example if the amount is 1350 Thousands = 1 Hundreds=3 tens=0........
2 AnswersProgramming & Design1 decade ago