Solved Excel : How to copy specific cells if 2 others cells matched

November 27, 2015 at 16:02:57
Specs: Windows 7
Hi , i am working in finance and mostly with numbers .. i have two sheets the 1st sheet includes two columns [order number] and [value] order no. aren't sequentially and each order no. has unique value and both columns already filled... and the 2nd sheet have same columns but only contains a randomly group of [Order Value] and [value] column is empty and i need to fill each value of order no. from 1st sheet ...

See More: Excel : How to copy specific cells if 2 others cells matched

Report •


#1
November 28, 2015 at 09:48:05
✔ Best Answer
Without knowing how your spreadsheet is arraigned, Column Letter & Row Numbers,
the best I can offer is a general suggestion of using one of the =LOOKUP() functions,
like =VLOOKUP()

Somthing like:

=IF(VLOOKUP(A1,SheetName!A1:B10,2,FALSE)

Where cell A1 is your unique value.

MIKE

http://www.skeptic.com/


Report •

#2
November 28, 2015 at 23:47:32
many thanx , it was helpful :)

Report •

Related Solutions


Ask Question