Copy from one sheet to another based on referencing a parallel cell.
I am trying to take data that exists in one sheet and make it automatically copy to another sheet. The data is in rows with titles (name) to define what is in each row. The data does not all need to be copied. only certain cells from certain rows. The title (name) of the row is already listed on the page that is being copied to. Is there a way that excel can find those names from the copy from page and transfer certain lines of code to the copy to page.
I attached a ecel sheet with an example of my problem. Basically just need the things in sheet 1 copied to sheet 2 but automatically because im dealing with thousands of lines of code.
Thanks for any help!!
| Attachment | Size |
|---|---|
| QUESTIONTEST.xlsx | 9.5 KB |
Use simple Vlookup in Num2
Use simple Vlookup in Num2 field
That's Good stuff! Now is
That's Good stuff! Now is there a way to use the vlookup when I have multiple constraints. I mean I have more than one name that are the same but I want it to pick one of them based on info that matches in another sheet to the one I want.
Try using 'IF' construct(s)
Try using 'IF' construct(s) in your formula. Based on condition match/mismatch put the relevant formula in the If construct.
=if(a=b, vlookup(), "")
means if a=b is true then execute vlookup else put blank ("").