Hi,
I need some help in automating my table by using a vlookup or whatever formula applicable using the right table below.
For Ex.
If Colour is Yelllow, I need to update the column A, B, C, D, E if they exist on the other table.
Another is, if colour is Orange, if on the table it contans column A and B state Y and if not input N.
I had attached my excel table for easier reference.
Appreciate any help in populating the table.
Many thanks!
Enter formula in C4 and drag formula across and down
Formula:
Please Login or Register to view this content.
v B C D E F G 2 3 COLOUR A B C D E 4 YELLOW 1281272 6142748.4 194710.41 290.5 131208.91 5 BLUE 6 RED 7 GREEN 65809.52 317389.22 5172.07 4362 8 ORANGE 3371.7 422900.32
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try this in C4:
=IFERROR(INDEX($L$4:$L$14,INDEX(MATCH($B4&C$3,$J$4:$J$14&$K$4:$K$14,0),0)),"")
Drag the formula to the right and down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks