Hi everyone,
I'm new to Excel and I can't figure out what formula to use.
Here is an example of a formula that I need to do in the same manor. =VLOOKUP($H:$H,'FBE Coating 20 x 456'!$G$2:$J$3877,2,FALSE)
(G) = 9568 4169 04 (9568= A constant number that stays the same) (4169= A coil number - this will change per each line) & (04= A pipe number - this will change per each line as well)
What I'm trying to do, is take a sequence number from my first worksheet titled "FBE Coating 20 x 456" column (B) and apply it to column (H) on worksheet titled "Powercrete 20 x 456" - {Noted: Each series of numbers in column (G) has it's own sequence number located in column (B).} As I input the numbers from column (G) on worksheet titled "Powercrete 20 x 456 in column (H) the sequence number will automatically appear in column (I) with the correct sequence number.
I hope I've been descriptive enough on whats needed.